package com.chen.service.provider;

import java.sql.SQLException;
import java.util.List;

import com.chen.pojo.Provider;
import com.mysql.jdbc.SQLError;

public interface ProviderService {
	/**
	 * 婢х偛濮炴笟娑樼安閸燂拷
	 * @param provider
	 * @return
	 * @throws Exception 
	 */
	public boolean add(Provider provider) throws Exception;


	/**
	 * 闁俺绻冩笟娑樼安閸熷棗鎮曠粔鑸拷浣虹椽閻浇骞忛崣鏍︾返鎼存柨鏅㈤崚妤勩��-濡紕纭﹂弻銉嚄-providerList
	 * @param proName
	 * @return
	 */
	public List<Provider> getProviderList(String proName,String proCode,int currentPageNo, int pageSize) throws Exception;
	
	/**
	 * 闁俺绻僷roId閸掔娀娅嶱rovider
	 * @param delId
	 * @return
	 */
	public int deleteProviderById(String delId) throws Exception;
	
	
	/**
	 * 闁俺绻僷roId閼惧嘲褰嘝rovider
	 * @param id
	 * @return
	 */
	public Provider getProviderById(String id) throws Exception;
	
	/**
	 * 娣囶喗鏁奸悽銊﹀煕娣団剝浼�
	 * @param user
	 * @return
	 */
	public boolean modify(Provider provider) throws Exception;
	/**
	 * 鏌ユ壘鎬昏褰曟暟
	 * @param proName
	 * @param proCode
	 * @return
	 */
	public int getProvierCount(String proName,String proCode) throws Exception;
	
	
	public List<Provider> queryList() throws SQLException;
}
